From 3ad4f5e1e2355895e5e465c4b8049197c8dce295 Mon Sep 17 00:00:00 2001
From: Stevan Earl <stevan.earl@asu.edu>
Date: Thu, 10 Sep 2026 18:17:17 -0700
Subject: [PATCH] trim groom scan direction codes

---
 conversion/clean.sql | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/conversion/clean.sql b/conversion/clean.sql
index a290aec..91a770d 100644
--- a/conversion/clean.sql
+++ b/conversion/clean.sql
@@ -624,6 +624,12 @@ UPDATE groom_scans
   SET gs_comments = ''
   WHERE gs_comments IS NULL;
 
+-- Problem #136
+-- Remove Access padding from B-record groom-scan direction codes.
+UPDATE groom_scans
+  SET gs_direction = BTRIM(gs_direction)
+  WHERE gs_direction IS DISTINCT FROM BTRIM(gs_direction);
+
 
 --
 -- Aggression
-- 
2.34.1